Below are the sales for the and percent of sales for the portfolio
This report is built from the Sales data present with the Warehouse (data extracted from MRI).
select dimd.fulldate, dimc.CENTERNAME, dimc.BldgGroupName, dimc.[BLDGID], diml.TenantName, diml.ChainName, diml.leasid
,dime.PORTID,fas.ISTEMP, fas.IsCurrentlyOpen,fas.ISNONREPORTING, fas.IsOpenForFullYear, diml.zPopUpProgram, lastlsf, [CurrentYearSales1M]
from warehouse.dbo.FactAdjustedSales fas
left join warehouse.dbo.DimLease diml on fas.LeaseKey = diml.LeaseKey
left join warehouse.dbo.DimCenter dimc on fas.CenterKey = dimc.CenterKey
left join warehouse.dbo.DimTenant dimt on fas.TenantKey = dimt.TenantKey
left join warehouse.dbo.DimEntity dime on fas.EntityKey = dime.EntityKey
left join warehouse.dbo.DimDate dimd on fas.dateKey = dimd.DateKey
where fas.DateKey > 20161231
--and lastlsf > 0
order by CENTERNAME, fas.datekey desc, tenantnameThe report uses full year sales data. The percent of sales by month are calculated from the ratio of total gross sale for that month divided by the total sales for that calendar year.
Exclusions/Inclusions
This report was last run on 04 February, 2022.
The using data from CY 2021
Code is available upon request.